USE [LAFDC]
GO
/****** Object:  Table [dbo].[Divers]    Script Date: 11/23/2009 22:55:54 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE TABLE [dbo].[Divers](
	[PREV_ID] [nvarchar](50) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL,
	[RUB2] [nchar](10) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
	[INDICE_RETRAITE] [nvarchar](50) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
	[OTIG] [nvarchar](50) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
	[AFFECTATION] [nvarchar](50) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
	[CREATED] [datetime] NULL,
	[LAST_MODIFIED] [datetime] NULL,
 CONSTRAINT [PK_Divers] PRIMARY KEY CLUSTERED 
(
	[PREV_ID] ASC
)WITH (PAD_INDEX  = OFF, IGNORE_DUP_KEY = OFF) ON [PRIMARY]
) ON [PRIMARY]

GO
ALTER TABLE [dbo].[Divers]  WITH CHECK ADD  CONSTRAINT [FK_Divers_Adherent] FOREIGN KEY([PREV_ID])
REFERENCES [dbo].[Adherent] ([PREV_ID])
GO
ALTER TABLE [dbo].[Divers] CHECK CONSTRAINT [FK_Divers_Adherent]